{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Notes Balance","Cumulative Defaults","Collateral Tables"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":7,"defined_names":24,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Notes Balance","index":0,"n_rows":108,"n_cols":6,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
["TOTAL NOTE BALANCES"]
[null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes"]
["Initial Invested Amount",{"$f":"SUM(C3:F3)","v":423450000},115000000,286850000,11250000,10350000]
["Invested Amount as at Previous Payment Date:  16 August 2018",{"$f":"SUM(C4:F4)","v":423450000},115000000,286850000,11250000,10350000]
["Stated Amount as at Previous Payment Date:  16 August 2018",423450000,115000000,286850000,11250000,10350000]
["Principal Payments to Noteholders on Payment Date",39614786.810000002,39614786.810000002,0,0,0]
["Gross Aggregate Charge-Offs",0,0,0,0,0]
["Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
["Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
["Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0]
["Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0]
["Invested Amount as at Payment Date:  16 November 2018",383835213.19,75385213.189999998,286850000,11250000,10350000]
["Stated Amount as at Payment Date:  16 November 2018",383835213.19,75385213.189999998,286850000,11250000,10350000]
["Bond Factor at Payment Date:  16 November 2018",null,0.65552359295652174,1,1,1]
["Coupon Margin",null,7.3000000000000001E-3,1.0800000000000001E-2,1.7000000000000001E-2,2.2499999999999999E-2]
["Coupon Rate (3 month BBSW + margin)",null,2.6850000000000002E-2,3.0350000000000002E-2,3.6549999999999999E-2,4.2050000000000004E-2]
["Days in Coupon Period",null,92,92,92,92]
["Coupon Entitlement to be paid out on the current Payment Date: 16 November 2018",null,778282.19,2194363.21,103641.78,109698.66]
[]
[]
["TOTAL NOTE BALANCES"]
[null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes"]
["Initial Invested Amount",{"$f":"SUM(C25:F25)","v":423450000},115000000,286850000,11250000,10350000]
["Invested Amount as at Previous Payment Date:  16 November 2018",{"$f":"SUM(C26:F26)","v":383835213.19},75385213.189999998,286850000,11250000,10350000]
["Stated Amount as at Previous Payment Date:  16 November 2018",383835213.19,75385213.189999998,286850000,11250000,10350000]
["Principal Payments to Noteholders on Payment Date",27133674.77,27133674.77,0,0,0]
["Gross Aggregate Charge-Offs",0,0,0,0,0]
["Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
["Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
["Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0]
["Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0]
["Invested Amount as at Payment Date:  18 February 2019",356701538.42000002,48251538.420000002,286850000,11250000,10350000]
["Stated Amount as at Payment Date:  18 February 2019",356701538.42000002,48251538.420000002,286850000,11250000,10350000]
["Bond Factor at Payment Date:  18 February 2019",null,0.41957859495652178,1,1,1]
["Coupon Margin",null,7.3000000000000001E-3,1.0800000000000001E-2,1.7000000000000001E-2,2.2499999999999999E-2]
["Coupon Rate (3 month BBSW + margin)",null,2.6710000000000001E-2,3.0210000000000001E-2,3.6409999999999998E-2,4.1910000000000003E-2]
["Days in Coupon Period",null,94,94,94,94]
["Coupon Entitlement to be paid out on the current Payment Date: 18 February 2019",null,518555.26,2231724.44,105489.25,111710.24]
[]
[]
["TOTAL NOTE BALANCES"]
[null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes"]
["Initial Invested Amount",{"$f":"SUM(C47:F47)","v":423450000},115000000,286850000,11250000,10350000]
["Invested Amount as at Previous Payment Date:  18 February 2019",{"$f":"SUM(C48:F48)","v":356701538.42000002},48251538.420000002,286850000,11250000,10350000]
["Stated Amount as at Previous Payment Date:  18 February 2019",{"$f":"SUM(C49:F49)","v":356701538.42000002},48251538.420000002,286850000,11250000,10350000]
["Principal Payments to Noteholders on Payment Date",{"$f":"SUM(C50:F50)","v":60199851.230000004},48251538.420000002,11948312.810000001,0,0]
["Gross Aggregate Charge-Offs",{"$f":"SUM(B51:F51)","v":0},0,0,0,0]
["Gross Aggregate Reinstatements of charge-offs",{"$f":"SUM(C52:F52)","v":0},0,0,0,0]
["Aggregate Charge-Offs for this Collection Period",{"$f":"SUM(C53:F53)","v":0},0,0,0,0]
["Reinstatements relating to Charge-offs that have occurred this Collection Period",{"$f":"SUM(C54:F54)","v":0},0,0,0,0]
["Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Aggregate Charge-Offs not reinstated and to be carried over to next period",{"$f":"SUM(C57:F57)","v":0},0,0,0,0]
["Invested Amount as at Payment Date:  16 May 2019",{"$f":"SUM(C58:F58)","v":296501687.19},0,274901687.19,11250000,10350000]
["Stated Amount as at Payment Date:  16 May 2019",{"$f":"SUM(C59:F59)","v":296501687.19},0,274901687.19,11250000,10350000]
["Bond Factor at Payment Date:  16 May 2019",null,0,0.95834647791528671,1,1]
["Coupon Margin",null,7.3000000000000001E-3,1.0800000000000001E-2,1.7000000000000001E-2,2.2499999999999999E-2]
["Coupon Rate (3 month BBSW + margin)",null,2.6800000000000001E-2,3.0300000000000001E-2,3.6500000000000005E-2,4.1999999999999996E-2]
["Days in Coupon Period",null,87,87,87,87]
["Coupon Entitlement to be paid out on the current Payment Date: 16 May 2019",null,308228.18,2071685.71,97875,103613.42]
[]
[]
["TOTAL NOTE BALANCES"]
[null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes"]
["Initial Invested Amount",{"$f":"SUM(C69:F69)","v":423450000},115000000,286850000,11250000,10350000]
["Invested Amount as at Previous Payment Date:  16 May 2019",{"$f":"SUM(C70:F70)","v":296501687.19},0,274901687.19,11250000,10350000]
["Stated Amount as at Previous Payment Date:  16 May 2019",296501687.19,0,274901687.19,11250000,10350000]
["Principal Payments to Noteholders on Payment Date",19267098.829999998,0,19267098.829999998,0,0]
["Gross Aggregate Charge-Offs",0,0,0,0,0]
["Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
["Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
["Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0]
["Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Aggregate Charge-Offs not reinstated and to be carried over to next period",{"$f":"SUM(C79:G79)","v":0},0,0,0,0]
["Invested Amount as at Payment Date:  16 August 2019",{"$f":"SUM(C80:F80)","v":277234588.36000001},0,255634588.36000001,11250000,10350000]
["Stated Amount as at Payment Date:  16 August 2019",{"$f":"SUM(C81:F81)","v":277234588.36000001},0,255634588.36000001,11250000,10350000]
["Bond Factor at Payment Date:  16 August 2019",null,0,0.89117862422869099,1,1]
["Coupon Margin",null,7.3000000000000001E-3,1.0800000000000001E-2,1.7000000000000001E-2,2.2499999999999999E-2]
["Coupon Rate (3 month BBSW + margin)",null,2.3550000000000001E-2,2.7050000000000001E-2,3.3250000000000002E-2,3.875E-2]
["Days in Coupon Period",null,92,92,92,92]
["Coupon Entitlement to be paid out on the current Payment Date: 16 August 2019",null,0,1874302.3,94284.25,101089.73]
[]
[]
["TOTAL NOTE BALANCES"]
[null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes"]
["Initial Invested Amount",{"$f":"SUM(C91:F91)","v":423450000},115000000,286850000,11250000,10350000]
["Invested Amount as at Previous Payment Date:  16 August 2019",{"$f":"SUM(C92:F92)","v":277234588.36000001},0,255634588.36000001,11250000,10350000]
["Stated Amount as at Previous Payment Date:  16 August 2019",277234588.36000001,0,255634588.36000001,11250000,10350000]
["Principal Payments to Noteholders on Payment Date",20024406.32,0,20024406.32,0,0]
["Gross Aggregate Charge-Offs",{"$f":"SUM(C95:G95)","v":0},0,0,0,0]
["Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
["Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
["Reinstatements relating to Charge-offs that have occurred this Collection Period",{"$f":"SUM(C98:G98)","v":0},0,0,0,0]
["Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0]
["Invested Amount as at Payment Date:  18 November 2019",257210182.04000002,0,235610182.04000002,11250000,10350000]
["Stated Amount as at Payment Date:  18 November 2019",257210182.04000002,0,235610182.04000002,11250000,10350000]
["Bond Factor at Payment Date:  18 November 2019",null,0,0.82137068865260598,1,1]
["Coupon Margin",null,7.3000000000000001E-3,1.0800000000000001E-2,1.7000000000000001E-2,2.2499999999999999E-2]
["Coupon Rate (3 month BBSW + margin)",null,1.695E-2,2.0450000000000003E-2,2.665E-2,3.2149999999999998E-2]
["Days in Coupon Period",null,94,94,94,94]
["Coupon Entitlement to be paid out on the current Payment Date: 18 November 2019",null,0,1346318.82,77211.990000000005,85695.16]

{"sheet":"Cumulative Defaults","index":1,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Cumulative Defaults & Losses"]
[]
["Month","Gross Losses","Recoveries","Net Losses"]
["2018-10-01",0,0,0]
["2019-01-01",0,0,{"$f":"B5-C5","v":0}]
["2019-04-01",0,0,0]
["2019-07-01",0,0,0]
["2019-10-01",{"$f":"B7+'Collateral Tables'!E9/450000000","v":5.1679500000000001E-4},{"$f":"C7+'Collateral Tables'!E23/450000000","v":0},{"$f":"B8-C8","v":5.1679500000000001E-4}]

{"sheet":"Collateral Tables","index":2,"n_rows":238,"n_cols":23,"rows_kept":238,"cut":false,"hidden":false,"merged":[]}
[null,"CNHI CAPITAL AUSTRALIA RECEIVABLES TRUST SERIES 2018-1 (TERM DEAL)"]
[null,"COLLATERAL DATA TABLES"]
[]
[null,"OUTSTANDING RECEIVABLES",null,null,"2019-10-31",null,null,null,"2019-07-31",null,null,null,"2019-04-30",null,null,null,"2018-01-31",null,null,null,"2018-10-31"]
[]
[null,"Opening Balance",null,null,{"$f":"I13","v":303784588.3599999},null,null,null,323051687.18999994,null,null,null,383251538.42000002,null,null,null,410385213.19,null,null,null,449999896.88999999]
[null,"Principal Repayments - Scheduled",null,null,{"$f":"MIN(([1]Sheet1!$B$3+[2]Sheet1!$B$3+[3]Sheet1!$B$3),'[4]18 Nov 19'!$H$23)","v":19571730.579999998},null,null,null,19267098.830000028,null,null,null,54340040.480000004,null,null,null,25925049.640000001,null,null,null,32152734.129999999]
[null,"Principal Repayments - Unscheduled",null,null,{"$f":"'[4]18 Nov 19'!$H$23-'Collateral Tables'!E7","v":452675.73999999836},null,null,null,0,null,null,null,5859810.7500000671,null,null,null,1208625.1300000101,null,null,null,7461949.5699999668]
[{"$f":"SUM(U9)","v":0},"Charge-Offs",null,null,{"$f":"'[4]18 Nov 19'!$H37","v":232557.75},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Reinstatements"]
[null,"New Receivables Purchased"]
[null,"Non Cash Change in Receivables"]
[null,"Closing Balance",null,null,{"$f":"E6-E7-E8-E9+E10+E11-E12","v":283527624.2899999},null,null,null,303784588.3599999,null,null,null,323051687.18999994,null,null,null,383251538.42000002,null,null,null,410385213.19]
[]
[null,"PORTFOLIO STATISTICS"]
[]
[null,"Summary"]
[null,"Number of contracts",null,null,{"$f":"[5]Summary!$D$4","v":3136},null,null,null,3213,null,null,null,3275,null,null,null,3359,null,null,null,3402]
[null,"Dollar value of contracts",null,null,{"$f":"[5]Summary!$G$5","v":283751171.76999974},null,null,null,303784588.36000079,null,null,null,323051687.18999928,null,null,null,383251538.41999996,null,null,null,410385213.18999952]
[null,"Number of contracts closed during the Quarter",null,null,{"$f":"[5]Summary!$B$19","v":77},null,null,null,63,null,null,null,84,null,null,null,43,null,null,null,64]
[null,"Dollar value of contracts closed during the Quarter",null,null,{"$f":"[5]Summary!$B$20","v":7503678.2700000023},null,null,null,2932187.6999999997,null,null,null,13591506.540000001,null,null,null,6683029.9000000004,null,null,null,8769089.4699999988]
[]
[{"$f":"SUM(U23)","v":0},"Dollar Value of Recoveries from Collateral",null,null,{"$f":"[5]Summary!$C$16","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Dollar Value of Recoveries from Other Sources",null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[]
[null,"Average Term of Contracts (Months)",null,null,{"$f":"[6]Sheet1!$W$3137","v":55.229718859646013},null,null,null,54.947784815596883,null,null,null,54.732139457705259,null,null,null,54.130152888845871,null,null,null,53.786897918104366]
[null,"Average Term to Maturity (Months)",null,null,{"$f":"[6]Sheet1!$X$3137","v":31.293992521359257},null,null,null,33.97737814677452,null,null,null,36.718509707251606,null,null,null,39.110875570193862,null,null,null,41.776292365564615]
[null,"Average Residual / Balloon Payment *",null,null,{"$f":"[6]Sheet1!$AI$3137","v":4.035487075491407E-2},null,null,null,3.986054751657539E-2,null,null,null,3.9280139290494481E-2,null,null,null,3.9775154630899499E-2,null,null,null,3.9736399863039409E-2]
[null,"Average Seasoning (Months)",null,null,{"$f":"E26-E27","v":23.935726338286756},null,null,null,20.970406668822363,null,null,null,18.013629750453653,null,null,null,15.019277318652009,null,null,null,12.010605552539751]
[null,"Average Dollar Value of Individual Assets",null,null,{"$f":"E19/E18","v":90481.878753188692},null,null,null,94548.580255213441,null,null,null,98641.736546564673,null,null,null,114096.91527835664,null,null,null,120630.57412992344]
[null,"Weighted Average Interest Rate",null,null,{"$f":"[6]Sheet1!$AA$3137/100","v":2.5648800550332206E-2},null,null,null,2.5567676696328468E-2,null,null,null,2.5489074791593555E-2,null,null,null,2.5471722602341703E-2,null,null,null,2.550199740116188E-2]
[]
[null,"Payment in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$34,'[7]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":3129},{"$f":"IFERROR(VLOOKUP($A$34,'[7]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":40536.400000000001},{"$f":"F34/F$50","v":1.4297160674029506E-4},null,3204,81213.810000000027,2.6781077738541477E-4,null,3266,362832.45,1.1231405511484118E-3,null,3354,193610.88999999998,5.051796812041092E-4,null,3400,279239.7,6.8043314189957925E-4]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$35,'[7]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":3},{"$f":"IFERROR(VLOOKUP($A$35,'[7]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":182468.94},{"$f":"F35/F$50","v":6.4356670873581508E-4},null,4,139327.32999999996,4.5944600503700295E-4,null,6,249320.55,7.7176674781879377E-4,null,3,8888.9800000000032,2.3193592481444121E-5,null,1,45938.869999999995,1.1194085099438339E-4]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$36,'[7]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":2},{"$f":"IFERROR(VLOOKUP($A$36,'[7]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":65496.42},2.3100542729835889E-4,null,2,58160.67,1.9179070955982198E-4,null,2,44319.770000000004,1.3719095660978185E-4,null,2,16836.879999999994,4.3931669705520386E-5,null,1,2144.1999999999953,5.2248471218851559E-6]
["4. 91 - 120 Days","91 - 120 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$37,'[7]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A$37,'[7]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":3097.71},1.0925602074073656E-5,null,1,3052.8799999999983,1.0067181506007222E-5,null,1,3108.0499999999993,9.6209062612696854E-6,null,0,0,0,null,0,0,0]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$38,'[7]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A$38,'[7]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$39,'[7]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A$39,'[7]Arrears Reporting'!$A$1:$D$5,2,FALSE),0)","v":0},0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Total",null,null,{"$f":"SUM(E34:E39)","v":3135},{"$f":"SUM(F34:F39)","v":291599.47000000003},{"$f":"SUM(G34:G39)","v":1.0284693448485427E-3},null,3211,281754.69,9.2911467348824703E-4,null,3275,659580.82000000007,2.0417191618382572E-3,null,3359,219336.75,5.7230494339107374E-4,null,3402,327322.77,7.9759884001584784E-4]
[null,"* Expressed as a % of Aggreg. Rec. closing bal.",null,null,null,"> 30 days",{"$f":"SUM(G35:G39)","v":8.8549773810824755E-4},null,null,"> 30 days",6.6130389610283226E-4,null,null,"> 30 days",9.1857861068984535E-4,null,null,"> 30 days",6.7125262186964514E-5,null,null,"> 30 days",1.1716569811626855E-4]
[]
[" 0 - 30 Days","Account Balances in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$44,'[7]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":3129},{"$f":"IFERROR(VLOOKUP($A$44,'[7]Arrears Reporting'!$A$1:$D$5,4,FALSE),0)","v":282723462.42000002},{"$f":"F44/F$50","v":0.99716372656098784},null,3204,302305095.69000071,0.99688172103132788,null,3266,321682443.05999917,0.99576153233586195,null,3354,382732142.23999995,0.99864476426594062,null,3400,410108423.92999953,0.99932553793093948]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$45,'[7]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":3},{"$f":"IFERROR(VLOOKUP($A$45,'[7]Arrears Reporting'!$A$1:$D$5,4,FALSE),0)","v":439163.95},{"$f":"F45/F$50","v":1.5489282608696037E-3},null,4,615007.14999999991,2.02804846785403E-3,null,6,825480.22,2.5552574177224556E-3,null,3,196286.38,5.1216070993273489E-4,null,1,205758.3,5.0137844490205435E-4]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$46,'[7]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":2},{"$f":"IFERROR(VLOOKUP($A$46,'[7]Arrears Reporting'!$A$1:$D$5,4,FALSE),0)","v":333572.33},1.1765073362263033E-3,null,2,297182.14999999997,9.7998828791025705E-4,null,2,508259.23,1.5733062235984332E-3,null,2,323109.8,8.4307502412660511E-4,null,1,71030.959999999992,1.7308362415853951E-4]
["4. 91 - 120 Days","91 - 120 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$47,'[7]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A$47,'[7]Arrears Reporting'!$A$1:$D$5,4,FALSE),0)","v":31425.59},{"$f":"F47/F$50","v":1.108378419164442E-4},null,1,33431.029999999984,1.1024221290806472E-4,null,1,35504.679999999986,1.0990402281699989E-4,null,0,0,0,null,0,0,0]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$48,'[7]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A$48,'[7]Arrears Reporting'!$A$1:$D$5,4,FALSE),0)","v":0},{"$f":"F48/F$50","v":0},null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP($A$49,'[7]Arrears Reporting'!$A$1:$D$5,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A$49,'[7]Arrears Reporting'!$A$1:$D$5,4,FALSE),0)","v":0},{"$f":"F49/F$50","v":0},null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0]
[null,"Total",null,null,{"$f":"SUM(E44:E49)","v":3135},{"$f":"SUM(F44:F49)","v":283527624.28999996},{"$f":"SUM(G44:G49)","v":1.0000000000000002},null,3211,303250716.02000064,1.0000000000000002,null,3275,323051687.18999922,0.99999999999999978,null,3359,383251538.41999996,1,null,3402,410385213.18999952,1]
["NSW",null,null,null,null,"> 30 days",{"$f":"SUM(G45:G49)","v":2.836273439012351E-3},null,null,"> 30 days",3.1182789686723519E-3,null,null,"> 30 days",4.2384676641378889E-3,null,null,"> 30 days",1.35523573405934E-3,null,null,"> 30 days",6.7446206906059385E-4]
[null,null,null,null,null,">90 days",{"$f":"SUM(G47:G49)","v":1.108378419164442E-4},null,null,">90 days",1.1024221290806472E-4,null,null,">90 days",1.0990402281699989E-4,null,null,">90 days",0,null,null,">90 days",0]
[]
["VIC","Geographic Distribution"]
["NSW","New South Wales",null,null,{"$f":"F55/F$63","v":0.28087696346845448},{"$f":"IFERROR(VLOOKUP($A$55,'[7]Geographic '!$A$1:$C$9,3,FALSE),0)","v":79636378.170000002},null,null,0.2807897352874128,85299594.150000051,null,null,0.28614818561721905,92440654.149999857,null,null,0.28738603144052582,110141138.66999999,null,null,0.28736145911134803,117928893.66000003]
["VIC","Victoria",null,null,{"$f":"F56/F$63","v":0.20669356898380692},{"$f":"IFERROR(VLOOKUP($A$56,'[7]Geographic '!$A$1:$C$9,3,FALSE),0)","v":58603336.57},null,null,0.20903558140595066,63501788.049999982,null,null,0.21114312852940728,68210143.910000011,null,null,0.20800308285426566,79717501.500000015,null,null,0.2030790640631952,83340645.00000003]
["QLD","Queensland",null,null,0.11832816045354662,{"$f":"IFERROR(VLOOKUP($A$57,'[7]Geographic '!$A$1:$C$9,3,FALSE),0)","v":33549302.219999999},null,null,0.1251462276122689,38017495.239999965,null,null,0.12751357715637754,41193476.23999998,null,null,0.12170686868550314,46644344.659999989,null,null,0.12788745367319404,52483119.93999999]
["SA","South Australia",null,null,0.18687299660017198,{"$f":"IFERROR(VLOOKUP($A$58,'[7]Geographic '!$A$1:$C$9,3,FALSE),0)","v":52983656.770000003},null,null,0.18293153477603216,55571780.98999995,null,null,0.17938524582265014,57950706.319999993,null,null,0.18110694805335675,69409516.459999979,null,null,0.17726510863908634,72746979.399999961]
["NT","Northern Territory",null,null,0,{"$f":"IFERROR(VLOOKUP($A$59,'[7]Geographic '!$A$1:$C$9,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["ACT","Australian Capital Territory",null,null,1.4563004258719882E-4,{"$f":"IFERROR(VLOOKUP($A$60,'[7]Geographic '!$A$1:$C$9,3,FALSE),0)","v":41290.14},null,null,1.5535857251609787E-4,47195.539999999994,null,null,1.6432549992775051E-4,53085.63,null,null,1.5384269621740196E-4,58960.45,null,null,1.5794933130300096E-4,64820.069999999992]
["TAS","Tasmania",null,null,8.539937320264139E-3,{"$f":"IFERROR(VLOOKUP($A$61,'[7]Geographic '!$A$1:$C$9,3,FALSE),0)","v":2421308.14},null,null,8.8134543113397093E-3,2677391.5900000003,null,null,9.2782870632002797E-3,2997366.2899999991,null,null,8.4380108774828634E-3,3233880.6500000004,null,null,8.4309414150312498E-3,3459933.69]
["WA","Western Australia",null,null,0.19854274313116882,{"$f":"IFERROR(VLOOKUP($A$62,'[7]Geographic '!$A$1:$C$9,3,FALSE),0)","v":56292352.280000001},null,null,0.19312810803447966,58669342.800000004,null,null,0.18636725031121798,60206254.649999984,null,null,0.19320521539264851,74046196.029999986,null,null,0.19581802376684221,80360821.430000022]
[null,"Total",null,null,{"$f":"SUM(E55:E62)","v":1},{"$f":"SUM(F55:F62)","v":283527624.28999996},null,null,1,303784588.35999995,null,null,1,323051687.18999982,null,null,1.0000000000000002,383251538.4199999,null,null,1,410385213.19]
["AG",null,null,null,null,null,{"$f":"E13-F63","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["CE","Top Industry Distribution"]
["AGRICULTURAL MACHINERY","Agricultural",null,null,{"$f":"F66/F$69","v":0.92958741794563071},{"$f":"IFERROR(VLOOKUP($A$66,'[7]Top Industry'!$A$1:$C$4,3,FALSE),)","v":263563712.18000001},null,null,0.92589605548612453,281272952.08000058,null,null,0.92260749972404432,298049909.40000004,null,null,0.92874675511393878,355943622.69999987,null,null,0.92796491411031079,380823079.10999954]
["CONSTRUCTION EQUIPMENT","Construction",null,null,{"$f":"F67/F$69","v":7.0412582054369233E-2},{"$f":"IFERROR(VLOOKUP($A$67,'[7]Top Industry'!$A$1:$C$4,3,FALSE),)","v":19963912.109999999},null,null,7.4103944513875503E-2,22511636.27999999,null,null,7.739250027595565E-2,25001777.790000018,null,null,7.1253244886061357E-2,27307915.719999999,null,null,7.2035085889689154E-2,29562134.080000013]
["MOTOR VEHICLE - AG","Motor Vehicle AG",null,null,{"$f":"F68/F$69","v":0},{"$f":"IFERROR(VLOOKUP($A$68,'[7]Top Industry'!$A$1:$C$4,3,FALSE),)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,"Total",null,null,{"$f":"SUM(E66:E68)","v":1},{"$f":"SUM(F66:F68)","v":283527624.29000002},{"$f":"F63-F69","v":0},null,1,303784588.36000055,-5.9604644775390625E-7,null,1,323051687.19000006,0,null,1.0000000000000002,383251538.41999984,0,null,1,410385213.18999958,0]
["COMBINE"]
["40-100 HP TRACTOR","Collateral Types"]
["100<140 HP TRACTOR","100<140 HP TRACTOR",null,null,{"$f":"IFERROR(F72/F$104,0)","v":9.9811552263615252E-2},{"$f":"IFERROR(VLOOKUP($A$72,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":28299332.289999999},null,null,0.10242532262080024,31115234.469999999,null,null,0.10698751939862909,34562498.649999969,null,null,0.1007218431245978,38601801.330000013,null,null,0.10051494735728245,41249848.099999994]
["4 EWD TRACTORS","4 EWD TRACTORS",null,null,9.956720534971758E-2,{"$f":"IFERROR(VLOOKUP($A$73,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":28230053.190000001},null,null,9.6995431332025456E-2,29465717.18,null,null,9.5233741317393636E-2,30765420.810000014,null,null,9.8382964059179165E-2,37705422.329999991,null,null,0.10508305251737765,43124530.910000004]
["40<60 HP TRACTOR","40<60 HP TRACTOR",null,null,1.2405556879362093E-2,{"$f":"IFERROR(VLOOKUP($A$74,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":3517318.07},null,null,1.3061447822026701E-2,3967866.55,null,null,1.3841218564415564E-2,4471429.0099999961,null,null,1.2975684091188728E-2,4972950.8900000006,null,null,1.318187026757088E-2,5409644.6399999997]
["4WD Vehicle","4WD Vehicle",null,null,4.2112184764710858E-3,{"$f":"IFERROR(VLOOKUP($A$75,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":1193996.77},null,null,4.0128796084788979E-3,1219050.98,null,null,4.1713415017933199E-3,1347558.91,null,null,3.9917368011279063E-3,1529839.27,null,null,3.7864806529483031E-3,1553915.6700000002]
["60<100 HP TRACTOR","60<100 HP TRACTOR",null,null,4.4231715133241492E-2,{"$f":"IFERROR(VLOOKUP($A$76,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":12540913.109999999},null,null,4.5921902639340317E-2,13950366.289999997,null,null,4.8387677358906166E-2,15631720.809999993,null,null,4.6421141121430046E-2,17790973.749999993,null,null,4.6930562093822771E-2,19259608.729999997]
["BACKHOE","BACKHOE",null,null,8.1743198949441606E-4,{"$f":"IFERROR(VLOOKUP($A$77,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":231764.55},null,null,8.4851766638843968E-4,257766.58999999997,null,null,8.3845350679346209E-4,270863.81999999995,null,null,7.4072842908954988E-4,283885.30999999994,null,null,7.2330018348534613E-4,296831.69999999995]
["BALERS, WINDROWERS, MOWERS, RAKES","BALERS, WINDROWERS, MOWERS, RAKES",null,null,2.3693990547914805E-2,{"$f":"IFERROR(VLOOKUP($A$78,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":6717900.8499999996},null,null,2.4826714550319397E-2,7541973.2600000007,null,null,2.5074670961974636E-2,8100414.7600000035,null,null,2.4731878491802983E-2,9478530.4800000042,null,null,2.5012008206172172E-2,10264558.319999998]
["COMBINES","COMBINES",null,null,0.32991066730882607,{"$f":"IFERROR(VLOOKUP($A$79,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":93538787.730000004},null,null,0.32641744449685411,99160589.009999976,null,null,0.3152474638837065,101841225.08999994,null,null,0.33365369818780866,127873293.13000005,null,null,0.32706074703977811,134220894.40000004]
["COMPACT TRACK LOADER","COMPACT TRACK LOADER",null,null,1.2799563919345393E-2,{"$f":"IFERROR(VLOOKUP($A$80,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":3629029.95},null,null,1.3703811876942968E-2,4163006.8499999987,null,null,1.4331192665392501E-2,4629715.9699999988,null,null,1.3198669053890551E-2,5058410.2200000007,null,null,1.3428185014669721E-2,5510728.5699999984]
["COMPACT WHEEL LOADER","COMPACT WHEEL LOADER",null,null,8.1379929231868502E-4,{"$f":"IFERROR(VLOOKUP($A$81,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":230734.58},null,null,8.1386330799312694E-4,247239.12999999998,null,null,8.1613828515600298E-4,263654.84999999998,null,null,7.3054456912100159E-4,279982.32999999996,null,null,7.2181487168460697E-4,296222.15000000002]
["CRAWLER EXCAVATOR","CRAWLER EXCAVATOR",null,null,1.359919372814352E-2,{"$f":"IFERROR(VLOOKUP($A$82,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":3855747.09},null,null,1.4480800997010785E-2,4399044.169999999,null,null,1.4847184429589546E-2,4796407.9799999986,null,null,1.3548093509046269E-2,5192327.68,null,null,1.3638023520620305E-2,5596843.1899999995]
["CULTIVATORS,SEEDERS, HARROWS","CULTIVATORS,SEEDERS, HARROWS",null,null,1.3370599635549187E-2,{"$f":"IFERROR(VLOOKUP($A$83,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":3790934.35},null,null,1.2823333471359648E-2,3895531.080000001,null,null,1.2888812147113559E-2,4163752.5100000002,null,null,1.3427300647546348E-2,5146033.6300000008,null,null,1.2948548751779157E-2,5313892.9399999995]
["DRILL","DRILL",null,null,8.8534262094775871E-4,{"$f":"IFERROR(VLOOKUP($A$84,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":251019.09},null,null,9.3334303603313958E-4,283535.23,null,null,8.7767760158219312E-4,283535.23,null,null,9.270036109043831E-4,355275.56,null,null,8.6571238090762915E-4,355275.56]
["EXCAVATORS / GRADERS","EXCAVATORS / GRADERS",null,null,2.8899649621509557E-4,{"$f":"IFERROR(VLOOKUP($A$85,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":81938.490000000005},null,null,2.9826924561631514E-4,90609.600000000035,null,null,3.1343894495881918E-4,101256.98000000004,null,null,3.0035422812537088E-4,115111.22000000004,null,null,3.1812656938873664E-4,130554.44000000005]
["FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE","FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE",null,null,2.462636230767537E-4,{"$f":"IFERROR(VLOOKUP($A$86,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":69822.539999999994},null,null,2.3806602695162474E-4,72320.789999999994,null,null,2.3533583947910546E-4,76025.64,null,null,2.5778117005686193E-4,98795.03,null,null,2.4952117354333362E-4,102399.79999999999]
["FRONT END LOADER","FRONT END LOADER",null,null,1.2684699450383847E-3,{"$f":"IFERROR(VLOOKUP($A$87,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":359646.27},null,null,1.2917007808670915E-3,392398.79,null,null,1.3458826164380389E-3,434789.64999999997,null,null,1.1902396318631322E-3,456161.17,null,null,1.1590133482216555E-3,475641.93999999994]
["FRONTS","FRONTS",null,null,4.860158912030928E-3,{"$f":"IFERROR(VLOOKUP($A$88,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":1377989.31},null,null,4.5360737930754185E-3,1377989.3099999998,null,null,4.4856228506484535E-3,1449088.0299999998,null,null,4.3155367798875582E-3,1653936.1099999999,null,null,4.6322082007371939E-3,1900989.7500000002]
["GRADER","GRADER",null,null,8.4304631902645442E-4,{"$f":"IFERROR(VLOOKUP($A$89,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":239026.92},null,null,8.2522925653791691E-4,250691.92999999993,null,null,8.1177529912036253E-4,262245.37999999995,null,null,7.1412196054923256E-4,273688.33999999997,null,null,6.9452273337158605E-4,285021.85999999993]
["HARVESTERS - Other","HARVESTERS - Other",null,null,8.1124446189673252E-3,{"$f":"IFERROR(VLOOKUP($A$90,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":2300102.15},null,null,7.9354435095411752E-3,2410665.44,null,null,7.5681335122142713E-3,2444898.2999999998,null,null,1.0143172904213803E-2,3887386.62,null,null,1.0046950273744581E-2,4123119.83]
["IRRIGATION EQUIPMENT","IRRIGATION EQUIPMENT",null,null,1.3576314511290334E-3,{"$f":"IFERROR(VLOOKUP($A$91,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":384926.02},null,null,1.3503818354137914E-3,410225.18999999994,null,null,1.3470918037461065E-3,435180.27999999991,null,null,1.2544691718187515E-3,480777.23999999993,null,null,1.230692855802697E-3,505058.14999999985]
["MIDI CRAWLER EXCAVATOR","MIDI CRAWLER EXCAVATOR",null,null,6.6077628403634801E-4,{"$f":"IFERROR(VLOOKUP($A$92,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":187348.33},null,null,7.0262850117680661E-4,213447.71,null,null,7.4113313594670945E-4,239424.31000000003,null,null,8.2862558441181575E-4,317572.03000000003,null,null,8.4510561992259174E-4,346818.85000000003]
["MINI EXCAVATOR","MINI EXCAVATOR",null,null,1.6372783504339929E-2,{"$f":"IFERROR(VLOOKUP($A$93,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":4642136.41},null,null,1.7403187694745227E-2,5286820.2099999962,null,null,1.8399775131042875E-2,5944078.4000000022,null,null,1.7063660036331689E-2,6539673.9599999944,null,null,1.7348859415906182E-2,7119715.3700000001]
["OTHER AG","OTHER AG",null,null,8.0208083628351013E-3,{"$f":"IFERROR(VLOOKUP($A$94,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":2274120.7400000002},null,null,8.0648504034597484E-3,2449977.2599999998,null,null,8.9562377313891425E-3,2893327.7099999995,null,null,9.0732938590039405E-3,3477353.8299999996,null,null,8.8496612530689859E-3,3631770.1199999992]
["OTHER CE","OTHER CE",null,null,1.392419172518437E-4,{"$f":"IFERROR(VLOOKUP($A$95,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":39478.93},null,null,1.4281929255932196E-4,43386.300000000032,null,null,1.463739762863055E-4,47286.36000000003,null,null,1.4623534254044188E-4,56044.920000000027,null,null,1.5155923751863776E-4,62197.670000000027]
["OVER 140 HP TRACTOR","OVER 140 HP TRACTOR",null,null,0.20055144592133317,{"$f":"IFERROR(VLOOKUP($A$96,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":56861875.009999998},null,null,0.20050827209119979,60911322.900000006,null,null,0.20357779868619061,65766151.340000018,null,null,0.19582862291801678,75051621.000000015,null,null,0.19333381135559227,79341337.390000001]
["SCRAPERS","SCRAPERS",null,null,6.737723016527168E-4,{"$f":"IFERROR(VLOOKUP($A$97,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":191033.06},null,null,7.2159661286116711E-4,219209.92999999993,null,null,7.6496752624807113E-4,247124.0499999999,null,null,7.1696862883528225E-4,274779.32999999996,null,null,7.3633150096004277E-4,302179.55999999994]
["SKID STEER LOADER","SKID STEER LOADER",null,null,1.6173746778584134E-2,{"$f":"IFERROR(VLOOKUP($A$98,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":4585704},null,null,1.6821638311500561E-2,5110154.4700000035,null,null,1.7924461346627656E-2,5790527.4800000014,null,null,1.6469757997638352E-2,6312060.0899999989,null,null,1.6641691636287276E-2,6829504.1699999953]
["SKIDSTEER / UNILOADER","SKIDSTEER / UNILOADER",null,null,2.2606329863097098E-4,{"$f":"IFERROR(VLOOKUP($A$99,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":64095.19},null,null,2.3335100830063711E-4,70888.439999999988,null,null,2.4042276539580393E-4,77668.979999999981,null,null,2.203169760207638E-4,84436.819999999992,null,null,2.3410519412530575E-4,96073.309999999969]
["SPRAYING EQUIPMENT","SPRAYING EQUIPMENT",null,null,7.6231307669311688E-2,{"$f":"IFERROR(VLOOKUP($A$100,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":21613681.559999999},null,null,7.3587231599479955E-2,22354666.860000003,null,null,7.1263128294575415E-2,23021673.830000006,null,null,7.0390038122785506E-2,26977090.399999999,null,null,7.1966060766245121E-2,29533807.190000009]
["TRENCHERS","TRENCHERS",null,null,2.894773664665972E-4,{"$f":"IFERROR(VLOOKUP($A$101,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":82074.83},null,null,3.2304538729168071E-4,98136.21,null,null,3.5313763872374978E-4,114081.71,null,null,3.3897364257317355E-4,129912.17,null,null,3.5485779048422244E-4,145628.39000000001]
["UNDER 40 HP TRACTORS","UNDER 40 HP TRACTORS",null,null,8.5103922626318293E-4,{"$f":"IFERROR(VLOOKUP($A$102,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":241293.13},null,null,9.6621586889774084E-4,293521.48999999993,null,null,1.1181456538487363E-3,361218.83999999985,null,null,1.0603504207063422E-3,406380.92999999993,null,null,1.1130656157158311E-3,456785.67000000004]
["WHEEL LOADERS","WHEEL LOADERS",null,null,6.7146888588631506E-3,{"$f":"IFERROR(VLOOKUP($A$103,[7]Collateral!$A$1:$C$34,3,FALSE),\"\")","v":1903799.78},null,null,6.7851853549507042E-3,2061234.7400000002,null,null,6.8640456246737763E-3,2217441.52,null,null,6.2361949278877974E-3,2390031.2999999998,null,null,6.1986026012644489E-3,2543814.85]
[null,"Total",null,null,{"$f":"SUM(E72:E103)","v":1.0000000000000002},{"$f":"SUM(F72:F103)","v":283527624.28999996},{"$f":"F69-F104","v":0},null,1,303784588.36000001,5.3644180297851563E-7,null,1.0000000000000002,323051687.18999988,0,null,0.99999999999999989,383251538.42000008,0,null,0.99999999999999978,410385213.19000012,-5.3644180297851563E-7]
["$ 0 - $25,000"]
["$ 25,001 to $50,000","Contract Balance Distribution"]
["$0 - $25,000","$ 0 - $25,000",null,null,{"$f":"IFERROR(F107/F$118,0)","v":4.5042950654210476E-2},{"$f":"IFERROR(VLOOKUP($A$107,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":12770920.789999999},null,null,3.8182901814143896E-2,11599377.109999999,null,null,3.2887207995763938E-2,10624268.030000005,null,null,2.555686834390767E-2,9794709.1100000124,null,null,2.0816799035214772E-2,8542906.5099999998]
["$25,001 - $50,000","$ 25,001 to $50,000",null,null,{"$f":"IFERROR(F108/F$118,0)","v":9.7462876216025299E-2},{"$f":"IFERROR(VLOOKUP($A$108,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":27633417.75},null,null,9.7039423688820611E-2,29479081.379999999,null,null,9.6019375877013521E-2,31019221.380000021,null,null,8.1715914929164135E-2,31317750.109999999,null,null,7.8179603306383891E-2,32083753.169999979]
["$50,001 - $75,000","$ 50,001 to $75,000",null,null,8.0898372874381619E-2,{"$f":"IFERROR(VLOOKUP($A$109,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":22936923.469999999},null,null,8.2792945375472937E-2,25151220.830000009,null,null,8.368573838804845E-2,27034818.980000015,null,null,7.659304401233985E-2,29354401.950000018,null,null,7.4406360898444046E-2,30535270.280000035]
["$75,001 - $100,000","$ 75,001 to $100,000",null,null,6.8065358281495153E-2,{"$f":"IFERROR(VLOOKUP($A$110,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":19298409.329999998},null,null,6.9164500290912631E-2,21011109.249999989,null,null,6.7957200134008619E-2,21953688.159999989,null,null,5.8935603371921885E-2,22587160.660000004,null,null,5.940096749712527E-2,24377278.710000012]
["$100,001 - $125,000","$100,001 to $125,000",null,null,6.1273775257364708E-2,{"$f":"IFERROR(VLOOKUP($A$111,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":17372807.93},null,null,6.3825468120926682E-2,19389193.56000001,null,null,6.5094022578597893E-2,21028733.820000015,null,null,5.1387226601077245E-2,19694233.650000002,null,null,5.1689211960419867E-2,21212488.270000003]
["$125,001 - $150,000","$125,001 to $150,000",null,null,6.1906359473626299E-2,{"$f":"IFERROR(VLOOKUP($A$112,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":17552163.030000001},null,null,5.9429520429144914E-2,18053772.399999995,null,null,5.8213993536394448E-2,18806128.829999991,null,null,4.5620575359150553E-2,17484155.689999994,null,null,4.2201208774990076E-2,17318752.059999999]
["$150,001 - $200,000","$150,000 to $200,000",null,null,0.13870917505299002,{"$f":"IFERROR(VLOOKUP($A$113,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":39327882.869999997},null,null,0.13193984160414909,40081290.470000029,null,null,0.12641494265275627,40838560.510000028,null,null,0.10161435578458648,38943858.18,null,null,9.5551640116831357E-2,39212980.199999988]
["$200,001 - $300,000","$200,001 to $300,000",null,null,0.22086239546080313,{"$f":"IFERROR(VLOOKUP($A$114,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":62620590.280000001},null,null,0.22350231809501533,67896559.700000003,null,null,0.23152981224335575,74796096.480000034,null,null,0.22285078244461629,85407905.209999919,null,null,0.21822218533136511,89555158.049999952]
["$300,001 - $400,000","$300,001 to $400,000",null,null,0.13574313383529249,{"$f":"IFERROR(VLOOKUP($A$115,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":38486928.25},null,null,0.14063806146535088,42723675.609999985,null,null,0.14274477425303916,46113940.159999996,null,null,0.1677875304430721,64304829.169999972,null,null,0.16993880933938918,69740374.499999985]
["$400,001 - $500,000","$400,001 to $500,000",null,null,4.5889814308506152E-2,{"$f":"IFERROR(VLOOKUP($A$116,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":13011030.029999999},null,null,5.0287829848354199E-2,15276667.689999999,null,null,4.5881774148675017E-2,14822184.549999999,null,null,9.1736482298136746E-2,35158147.970000006,null,null,0.1000432276320633,41056261.29999999]
["$500,001+","$500,000+",null,null,4.4145788585304553E-2,{"$f":"IFERROR(VLOOKUP($A$117,'[7] Balance Distribution'!$A$1:$C$13,3,FALSE),\"\")","v":12516550.560000001},null,null,4.3197189267709046E-2,13122640.360000001,null,null,4.9571158192346698E-2,16014046.289999999,null,null,7.6201616412026829E-2,29204386.720000003,null,null,8.9549986107773122E-2,36749990.140000008]
["$200,001 to $300,000","Total",null,null,{"$f":"SUM(E107:E117)","v":0.99999999999999989},{"$f":"SUM(F107:F117)","v":283527624.29000002},{"$f":"F104-F118","v":0},null,1.0000000000000002,303784588.35999995,0,null,0.99999999999999989,323051687.19000018,0,null,0.99999999999999989,383251538.42000002,0,null,1,410385213.18999994,0]
["0"]
["0 to 5","Residual / Balloon Payment Distribution"]
["0","0",null,null,{"$f":"IFERROR(F121/F$131,0)","v":0.86163513340811493},{"$f":"IFERROR(VLOOKUP($A$121,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":244297362.38},null,null,0.86416124003269712,262518866.58000031,null,null,0.86620712575143011,279829673.42999977,null,null,0.87042987442471642,333593588.45999986,null,null,0.87028056701606027,357150276.02999955]
["0 to 5","0 to 5",null,null,{"$f":"IFERROR(F122/F$131,0)","v":0},{"$f":"IFERROR(VLOOKUP($A$122,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,"",null,null,0,"",null,null,0,""]
["6 to 10","06 to 10",null,null,2.1805641744722429E-3,{"$f":"IFERROR(VLOOKUP($A$123,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":618250.18000000005},null,null,2.1339612503046839E-3,648264.54,null,null,2.1914984445929107E-3,707967.27,null,null,1.9631919629125132E-3,752396.34,null,null,1.9054699703275168E-3,781976.70000000007]
["11 to 15","11 to 15",null,null,2.293251465807639E-3,{"$f":"IFERROR(VLOOKUP($A$124,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":650200.14},null,null,2.2186970828199761E-3,674005.98,null,null,2.1596541286276159E-3,697679.91,null,null,2.0210916652633024E-3,774586.49,null,null,1.9445128244192939E-3,797999.31]
["16 to 20","16 to 20",null,null,2.7106717411560059E-2,{"$f":"IFERROR(VLOOKUP($A$125,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":7685503.1900000004},null,null,2.7007913252917033E-2,8204587.8099999977,null,null,2.676864357285948E-2,8647655.4699999988,null,null,2.3728003904407664E-2,9093794,null,null,2.4046790558779521E-2,9868447.2700000014]
["21 to 25","21 to 25",null,null,1.2583423816054012E-2,{"$f":"IFERROR(VLOOKUP($A$126,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":3567748.26},null,null,1.1894562951685859E-2,3613384.9099999992,null,null,1.1349072193031697E-2,3666336.92,null,null,1.116499111168787E-2,4279000.0200000005,null,null,1.0535203391936823E-2,4323491.6899999995]
["26 to 30","26 to 30",null,null,5.0723315888578958E-2,{"$f":"IFERROR(VLOOKUP($A$127,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":14381461.25},null,null,4.7978725809248897E-2,14575197.469999999,null,null,4.7810375281884969E-2,15445222.399999999,null,null,4.2894833606601665E-2,16439510.969999997,null,null,4.1979094851119766E-2,17227599.789999995]
["31 to 35","31 to 35",null,null,1.4638048833488501E-2,{"$f":"IFERROR(VLOOKUP($A$128,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":4150291.21},null,null,1.5469940313202512E-2,4699529.4499999993,null,null,1.4924666365120439E-2,4821438.6499999985,null,null,1.3683446494748196E-2,5244201.92,null,null,1.6827689297866461E-2,6905834.8600000003]
["36 to 40","36 to 40",null,null,2.3081138447753051E-2,{"$f":"IFERROR(VLOOKUP($A$129,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":6544140.3499999996},null,null,2.231215930535493E-2,6778090.129999998,null,null,2.152154028500991E-2,6952569.8999999994,null,null,2.1923568694960083E-2,8402241.4299999997,null,null,2.1031024005253609E-2,8630821.2699999996]
["41+ %","41+%",null,null,5.7584065541707585E-3,{"$f":"IFERROR(VLOOKUP($A$130,'[7]Residual '!$A$1:$C$11,3,FALSE),\"\")","v":1632667.33},null,null,6.8228000017689829E-3,2072661.49,null,null,7.0674239774429388E-3,2283143.2400000002,null,null,1.2190998134702289E-2,4672218.790000001,null,null,1.1449648084236829E-2,4698766.2700000005]
[null,null,null,null,{"$f":"SUM(E121:E130)","v":1},{"$f":"SUM(F121:F130)","v":283527624.28999996},{"$f":"F118-F131","v":0},null,1,303784588.36000031,0,null,1,323051687.18999976,0,null,0.99999999999999989,383251538.41999984,0,null,1,410385213.18999952,0]
["2004 Q1"]
["2004 Q2","Quarter of Maturity Distribution"]
[{"$f":"RIGHT(B134,2)&LEFT(B134,4)","v":"Q42018"},"2018Q4",null,null,{"$f":"F134/F$157","v":0},{"$f":"IFERROR(VLOOKUP($A$134,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,3.8855875620005314E-3,1594587.68]
["Q12019","2019Q1",null,null,0,{"$f":"IFERROR(VLOOKUP($A$135,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":0},null,null,0,0,null,null,5.7271705221333135E-4,185017.21000000002,null,null,5.4528955542241901E-3,2089830.6099999999,null,null,5.2262312117152647E-3,2144768.0100000002]
[{"$f":"RIGHT(B136,2)&LEFT(B136,4)","v":"Q22019"},"2019Q2",null,null,0,{"$f":"IFERROR(VLOOKUP($A$136,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":0},null,null,0,0,null,null,3.7957096298302722E-4,122621.03999999998,null,null,8.2608842564655988E-4,316599.65999999992,null,null,9.2270349376522595E-4,378663.87]
[{"$f":"RIGHT(B137,2)&LEFT(B137,4)","v":"Q32019"},"2019Q3",null,null,0,{"$f":"IFERROR(VLOOKUP($A$137,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":0},null,null,2.0139928207120327E-3,611819.9800000001,null,null,2.1660969985537997E-3,699761.29,null,null,2.0568520174761096E-3,788291.7,null,null,2.1244020300418666E-3,871823.17999999993]
["Q42019","2019Q4",null,null,1.0384899557400371E-3,{"$f":"IFERROR(VLOOKUP($A$138,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":294440.59000000003},null,null,1.4296961947434588E-3,434319.67000000004,null,null,1.7375968684226572E-3,561333.59999999986,null,null,1.7471410363034221E-3,669594.48999999976,null,null,2.1337729817145802E-3,875668.87999999977]
["Q12020","2020Q1",null,null,7.5061540311261339E-3,{"$f":"IFERROR(VLOOKUP($A$139,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":2128202.02},null,null,7.2006854324280362E-3,2187457.2599999998,null,null,7.5056164884659254E-3,2424702.0700000003,null,null,1.2848810601781589E-2,4924326.4300000006,null,null,1.280247655406515E-2,5253947.0700000012]
["Q22020","2020Q2",null,null,9.8063368497602246E-3,{"$f":"IFERROR(VLOOKUP($A$140,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":2780367.39},null,null,1.0882727849518874E-2,3306004.9999999991,null,null,1.4468058968071776E-2,4673930.8599999975,null,null,1.6098489507532333E-2,6169770.8699999955,null,null,1.6080003805948036E-2,6598995.7899999944]
["Q32020","2020Q3",null,null,1.2425897049087847E-2,{"$f":"IFERROR(VLOOKUP($A$141,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":3523085.07},null,null,1.5223941263667334E-2,4624798.7299999995,null,null,1.662399146314144E-2,5370408.4899999984,null,null,1.6127886545431916E-2,6181037.3300000029,null,null,1.7146812272551611E-2,7036798.209999999]
["Q42020","2020Q4",null,null,2.6199012101911751E-2,{"$f":"IFERROR(VLOOKUP($A$142,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":7428143.6600000001},null,null,3.038365540473659E-2,9230086.2499999944,null,null,3.0259167116656334E-2,9775274.9899999965,null,null,2.9240167374668523E-2,11206339.130000006,null,null,3.198479874059907E-2,13126088.449999988]
["Q12021","2021Q1",null,null,5.317471899873618E-2,{"$f":"IFERROR(VLOOKUP($A$143,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":15076501.75},null,null,5.286755811643639E-2,16060349.380000006,null,null,5.1665538431884248E-2,16690639.359999994,null,null,5.500550864559791E-2,21080945.810000014,null,null,5.7437186312770339E-2,23571371.949999999]
["Q22021","2021Q2",null,null,3.058596096841015E-2,{"$f":"IFERROR(VLOOKUP($A$144,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":8671964.8499999996},null,null,3.03706324596907E-2,9226130.0799999945,null,null,3.381873858957575E-2,10925200.560000006,null,null,3.2174061064007768E-2,12330758.4,null,null,3.2160508287830306E-2,13198197.049999997]
["Q32021","2021Q3",null,null,2.4028076654117683E-2,{"$f":"IFERROR(VLOOKUP($A$145,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":6812623.4900000002},null,null,2.5446959444957409E-2,7730394.1000000006,null,null,2.6443245519952308E-2,8542535.0800000019,null,null,2.4994421260489084E-2,9579150.3999999985,null,null,2.4460156524578711E-2,10038086.550000001]
["Q42021","2021Q4",null,null,2.8770379677913106E-2,{"$f":"IFERROR(VLOOKUP($A$146,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":8157197.4000000004},null,null,3.0240228576419802E-2,9186515.3899999987,null,null,3.043261087882141E-2,9831306.2900000047,null,null,2.9083860056902833E-2,11146434.110000001,null,null,3.2073199269745847E-2,13162366.719999999]
["Q12022","2022Q1",null,null,0.16787049314573152,{"$f":"IFERROR(VLOOKUP($A$147,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":47595922.109999999},null,null,0.16460267089238587,50003754.619999997,null,null,0.15786299141043036,50997905.720000006,null,null,0.17660143794602942,67682772.779999956,null,null,0.17431526639065353,71536407.759999976]
["Q22022","2022Q2",null,null,0.14546785549832106,{"$f":"IFERROR(VLOOKUP($A$148,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":41244155.479999997},null,null,0.14177242062379383,43068276.439999983,null,null,0.14822244439119034,47883510.739999987,null,null,0.144861405355034,55518356.460000016,null,null,0.14115686844491698,57928691.550000027]
["Q32022","2022Q3",null,null,9.3903097614107936E-2,{"$f":"IFERROR(VLOOKUP($A$149,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":26624122.18},null,null,9.9031237767561731E-2,30084163.800000027,null,null,9.9574880910870384E-2,32167833.280000001,null,null,9.1128389135717136E-2,34925095.330000013,null,null,8.8528546259242502E-2,36330806.329999998]
["Q42022","2022Q4",null,null,0.12044390783972166,{"$f":"IFERROR(VLOOKUP($A$150,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":34149175.049999997},null,null,0.12071456194658148,36671223.509999976,null,null,0.11934325743770162,38554040.670000024,null,null,0.10883877414286509,41712627.629999973,null,null,0.11043002055977658,45318847.529999979]
["Q12023","2023Q1",null,null,0.21073902276585812,{"$f":"IFERROR(VLOOKUP($A$151,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":59750334.469999999},null,null,0.20292486160274556,61645445.550000034,null,null,0.19496915146261368,62985113.330000006,null,null,0.1901408154822353,72871760.050000042,null,null,0.1873616329699512,76890443.689999938]
["Q22023","2023Q2",null,null,5.0114007993333778E-2,{"$f":"IFERROR(VLOOKUP($A$152,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":14208705.630000001},null,null,4.7856509800199766E-2,14538070.129999993,null,null,4.7489812678108465E-2,15341664.109999992,null,null,4.7115311511708946E-2,18057015.619999994,null,null,4.4645410582854948E-2,18321816.340000004]
["Q32023","2023Q3",null,null,3.1150815452699104E-3,{"$f":"IFERROR(VLOOKUP($A$153,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":883211.67},null,null,3.0560198758333083E-3,928371.73999999987,null,null,3.0598698883086924E-3,988496.13,null,null,2.7983766338458413E-3,1072482.1499999999,null,null,2.7347714389514164E-3,1122309.7599999998]
["Q42023","2023Q4",null,null,1.1076113827934898E-2,{"$f":"IFERROR(VLOOKUP($A$154,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":3140384.24},null,null,1.04953299547299E-2,3188319.49,null,null,1.012625923255436E-2,3271305.1300000004,null,null,9.9495280194314539E-3,3813171.9200000009,null,null,9.3571542213976948E-3,3840037.7300000004]
["Q12024","2024Q1",null,null,3.7353934829176842E-3,{"$f":"IFERROR(VLOOKUP($A$155,'[7]Quarter of Maturity Dist'!$A$1:$C$23,3,FALSE),0)","v":1059087.24},null,null,3.4863099728579001E-3,1059087.24,null,null,3.2783832494801589E-3,1059087.24,null,null,2.9097796830704235E-3,1115177.54,null,null,3.0324900849286384E-3,1244489.0900000001]
[]
[null,null,null,null,{"$f":"SUM(E134:E155)","v":0.99999999999999989},{"$f":"SUM(F134:F156)","v":283527624.29000008},{"$f":"F131-F157","v":0},null,1,303784588.36000001,0,null,1.0000000000000002,323051687.19,0,null,0.99999999999999989,383251538.42000008,0,null,1,410385213.18999988,0]
["0 to 6 months"]
["07 to 12 months","Seasoning Distribution"]
["0 to 6 months","0 to 6 months",null,null,{"$f":"F160/F$171","v":0},{"$f":"IFERROR(VLOOKUP($A$160,'[7]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["07 to 12 months","07 to 12 months",null,null,{"$f":"F161/F$171","v":0},{"$f":"IFERROR(VLOOKUP($A$161,'[7]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0.21786977164980006,83498925.159999996,null,null,0.43992517129610625,180538785.20999968]
["13 to 18 months","13 to 18 months",null,null,0,{"$f":"IFERROR(VLOOKUP($A$162,'[7]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0.20692909235245824,62861869.139999941,null,null,0.43566455744038196,140742170.32999998,null,null,0.58043296889840068,222451828.28000012,null,null,0.51358685704501394,210768451.8199999]
["19 to 24 months","19 to 24 months",null,null,0.44823377866000175,{"$f":"IFERROR(VLOOKUP($A$163,'[7]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":127086658.39},null,null,0.59750107860935864,181511619.20999998,null,null,0.52099386860967278,168307948.26999986,null,null,0.20053466148327737,76855217.519999981,null,null,4.6458271587804363E-2,19065787.689999998]
["25 to 30 months","25 to 30 months",null,null,0.50739286586359589,{"$f":"IFERROR(VLOOKUP($A$164,'[7]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":143859893.84},null,null,0.19457863843294024,59109991.580000013,null,null,4.3322641159179907E-2,13995452.319999998,null,null,1.1625979685219391E-3,445567.45999999996,null,null,2.9700071075311855E-5,12188.469999999998]
["31 to 36 months","31 to 36 months",null,null,4.4373355476402282E-2,{"$f":"IFERROR(VLOOKUP($A$165,'[7]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":12581072.060000001},null,null,9.9119060524285548E-4,301108.43000000005,null,null,1.8932790765468986E-5,6116.2700000000041,null,null,0,0,null,null,0,0]
["37 to 42 months","37 to 42 months",null,null,0,{"$f":"IFERROR(VLOOKUP($A$166,'[7]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["43 to 48 months","43 to 48 months",null,null,0,{"$f":"IFERROR(VLOOKUP($A$167,'[7]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["49 to 54 months","49 to 54 months",null,null,0,{"$f":"IFERROR(VLOOKUP($A$168,'[7]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["55 to 60 months","55 to 60 months",null,null,0,{"$f":"IFERROR(VLOOKUP($A$169,'[7]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["60+ months","61 to 72 months",null,null,0,{"$f":"IFERROR(VLOOKUP($A$170,'[7]Seasoning Distribution'!$A$1:$C$6,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["61 to 72 months","Total",null,null,{"$f":"SUM(E160:E170)","v":1},{"$f":"SUM(F160:F170)","v":283527624.29000002},{"$f":"F157-F171","v":0},null,1,303784588.35999995,0,null,1.0000000000000002,323051687.18999982,0,null,1,383251538.42000008,0,null,0.99999999999999989,410385213.18999964,0]
[]
[null,"Remaining Term Distribution"]
["0 - 12 months","0-12 Months",null,null,{"$f":"F174/$V$180","v":3.0869983914685328E-2},{"$f":"IFERROR(VLOOKUP($A$174,'[7]Remaining Term'!$A$1:$C$8,3,FALSE),0)","v":12668584.93},null,null,2.0180270399181643E-2,8281684.5699999984,null,null,1.3333616792539294E-2,5471919.1699999981,null,null,1.1440246234764695E-2,4694907.8900000006,null,null,1.2729459839434824E-2,5223982.09]
["13 - 24 months","13-24 Months",null,null,{"$f":"F175/$V$180","v":9.1826586092303902E-2},{"$f":"IFERROR(VLOOKUP($A$175,'[7]Remaining Term'!$A$1:$C$8,3,FALSE),0)","v":37684273.109999999},null,null,9.7262407019329297E-2,39915053.639999978,null,null,9.6598559660204752E-2,39642620.50000003,null,null,8.621010904605883E-2,35379353.979999974,null,null,6.5982089387473686E-2,27078073.820000004]
["25 - 36 months","25-36 Months",null,null,0.33663238335548884,{"$f":"IFERROR(VLOOKUP($A$176,'[7]Remaining Term'!$A$1:$C$8,3,FALSE),0)","v":138148952.41},null,null,0.29008163962497474,119045215.51999992,null,null,0.24647603573174945,101150120.46999998,null,null,0.14333370360195374,58822032.510000013,null,null,0.14296399846852428,58670310.990000129]
["37 - 48 months","37-48 Months",null,null,0.22672028586693549,{"$f":"IFERROR(VLOOKUP($A$177,'[7]Remaining Term'!$A$1:$C$8,3,FALSE),0)","v":93042652.849999994},null,null,0.3201062122557034,131366856.16000015,null,null,0.41455037314230764,170125343.25999984,null,null,0.51795043059114643,212559197.87999979,null,null,0.47901013677358767,196578677.0999997]
["49 - 60 months","49-60 Months",null,null,4.8324377347432309E-3,{"$f":"IFERROR(VLOOKUP($A$178,'[7]Remaining Term'!$A$1:$C$8,3,FALSE),0)","v":1983160.99},null,null,1.2612000392917964E-2,5175778.4699999988,null,null,1.6232757847724353E-2,6661683.7899999991,null,null,0.17410865775253809,71451618.63000004,null,null,0.29353324710125128,120461704.18999986]
["60+ Months","60+ Months",null,null,0,{"$f":"IFERROR(VLOOKUP($A$179,'[7]Remaining Term'!$A$1:$C$8,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,8.3927860685501193E-4,344427.53,null,null,5.7810684297282386E-3,2372465]
[null,null,null,null,{"$f":"SUM(E174:E179)","v":0.6908816769641567},{"$f":"SUM(F174:F179)","v":283527624.28999996},{"$f":"F171-F180","v":0},null,0.74024252969210713,303784588.36000001,0,null,0.78719134317452544,323051687.18999988,0,null,0.93388242583331682,383251538.41999978,0,null,1,410385213.1899997,0]
[]
[null,"Origination LVR Distribution"]
["01. 10% to 20%","10% to 20%",null,null,{"$f":"F183/F$199","v":0},{"$f":"IFERROR(VLOOKUP($A$183,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":0},null,null,2.8957854799319703E-5,8796.9500000000007,null,null,2.7230781787640591E-5,8796.9500000000007,null,null,1.0180997618655297E-4,39018.83,null,null,9.5078547535130394E-5,39018.83]
["02. 21% to 30%","21% to 30%",null,null,{"$f":"F184/F$199","v":4.8964090306066318E-3},{"$f":"IFERROR(VLOOKUP($A$184,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":1388267.22},null,null,4.9367169285848677E-3,1499698.52,null,null,4.9667735648020817E-3,1604524.5800000003,null,null,5.5423815355235429E-3,2124126.2500000005,null,null,5.6091699116221794E-3,2301920.3899999997]
["03. 31% to 40%","31% to 40%",null,null,2.8040678469721893E-2,{"$f":"IFERROR(VLOOKUP($A$185,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":7950306.9500000002},null,null,2.854577431598835E-2,8671766.2999999952,null,null,2.8399489195684375E-2,9174502.8999999966,null,null,3.0010222157009863E-2,11501463.810000004,null,null,2.969824101424761E-2,12187718.969999997]
["04. 41% to 50%","41% to 50%",null,null,8.3893648315801664E-2,{"$f":"IFERROR(VLOOKUP($A$186,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":23786166.800000001},null,null,8.309832396791822E-2,25243990.139999997,null,null,8.0814737131043785E-2,26107337.179999985,null,null,8.4721443060241514E-2,32469623.390000004,null,null,8.2704000434553337E-2,33940498.849999994]
["05. 51% to 60%","51% to 60%",null,null,0.13592512978764185,{"$f":"IFERROR(VLOOKUP($A$187,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":38538529.130000003},null,null,0.13292617623559799,40380923.730000012,null,null,0.13081152606748614,42258884.199999981,null,null,0.13197393839179036,50579214.919999972,null,null,0.13161775661978506,54013981.109999977]
["06. 61% to 70%","61% to 70%",null,null,0.16793858862689803,{"$f":"IFERROR(VLOOKUP($A$188,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":47615229.060000002},null,null,0.16866655749922363,51238300.740000002,null,null,0.16857533868247776,54458547.580000013,null,null,0.16673158083966436,63900134.859999985,null,null,0.16608362562625806,68158264.109999999]
["07. 71% to 80%","71% to 80%",null,null,0.18135592286205873,{"$f":"IFERROR(VLOOKUP($A$189,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":51419413.960000001},null,null,0.17888226230753437,54341674.419999965,null,null,0.178739913176926,57742230.519999951,null,null,0.17669058219354097,67716937.450000063,null,null,0.17856535923986283,73280583.019999981]
["08. 81% to 90%","81% to 90%",null,null,0.21499556511520479,{"$f":"IFERROR(VLOOKUP($A$190,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":60957181.810000002},null,null,0.21870537935672335,66439323.639999948,null,null,0.2207810088855898,71323677.420000032,null,null,0.21375833774272157,81923211.790000021,null,null,0.2111981616888145,86672602.610000148]
["09. 91% to 100%","91% to 100%",null,null,0.18295405779206661,{"$f":"IFERROR(VLOOKUP($A$191,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":51872529.359999999},null,null,0.18420985153362809,55960113.920000017,null,null,0.18688398251420416,60373185.859999999,null,null,0.19046970410332101,72997807.11999999,null,null,0.19442860691732233,79790625.299999967]
["> 100%","> 100%",null,null,0,{"$f":"IFERROR(VLOOKUP($A$192,'[7]LVR Band'!$A$1:$C$11,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,{"$f":"SUM(E183:E192)","v":1.0000000000000002},{"$f":"SUM(F183:F192)","v":283527624.29000002},{"$f":"F180-F193","v":0},null,0.99999999999999822,303784588.35999995,0,null,1.0000000000000018,323051687.19,0,null,0.99999999999999967,383251538.42000008,0,null,1.0000000000000009,410385213.19000006,0]
[]
[null,"New v Used"]
["New","New",null,null,{"$f":"F196/F$199","v":0.95317232300292554},{"$f":"IFERROR(VLOOKUP($A$196,'[7]New v Used'!$A$1:$C$4,3,FALSE),0)","v":270250684.27999997},null,null,0.95375255263657122,289735326.6000005,null,null,0.95370597596908957,308096324.61999941,null,null,0.94991349691866422,364055809.06000012,null,null,0.9490331846817387,389469185.81999964]
["USed","Used",null,null,{"$f":"F197/F$199","v":4.6827676997074456E-2},{"$f":"IFERROR(VLOOKUP($A$197,'[7]New v Used'!$A$1:$C$4,3,FALSE),0)","v":13276940.01},null,null,4.6247447363428763E-2,14049261.759999998,null,null,4.6294024030910465E-2,14955362.570000002,null,null,5.0086503081335748E-2,19195729.360000003,null,null,5.0966815318261298E-2,20916027.370000001]
["Used"]
[null,null,null,null,{"$f":"SUM(E196:E197)","v":1},{"$f":"SUM(F196:F197)","v":283527624.28999996},{"$f":"F193-F199","v":0},null,1,303784588.36000049,-5.3644180297851563E-7,null,1,323051687.1899994,5.9604644775390625E-7,null,1,383251538.42000014,0,null,1,410385213.18999964,0]
[]
[null,"Contract Type"]
["Finance Lease","Finance Lease",null,null,{"$f":"F202/F$205","v":1.0801611616043212E-2},{"$f":"IFERROR(VLOOKUP($A$202,'[7]Loan Type'!$A$1:$C$5,3,FALSE),0)","v":3062555.28},null,null,1.081355439304614E-2,3284991.17,null,null,1.1725831345905024E-2,3788049.5999999996,null,null,1.5310912655931513E-2,5867930.8300000001,null,null,1.4946478827345518E-2,6133813.9000000022]
["Goods Mortgage","Goods Mortgage",null,null,{"$f":"F203/F$205","v":0.98338070601832994},{"$f":"IFERROR(VLOOKUP($A$203,'[7]Loan Type'!$A$1:$C$5,3,FALSE),0)","v":278815595.35000002},null,null,0.98375669793968468,298850123.53000075,null,null,0.98262601400159544,317438991.69999939,null,null,0.97992812565942067,375558961.69999999,null,null,0.98060734272529604,402426753.39999944]
["Hire Purchase","Hire Purchase",null,null,5.8176823656268216E-3,{"$f":"IFERROR(VLOOKUP($A$204,'[7]Loan Type'!$A$1:$C$5,3,FALSE),0)","v":1649473.66},null,null,5.4297476672690408E-3,1649473.6600000001,null,null,5.6481546524994744E-3,1824645.89,null,null,4.7609616846479462E-3,1824645.89,null,null,4.446178447358503E-3,1824645.89]
[null,null,null,null,{"$f":"SUM(E202:E204)","v":1},{"$f":"SUM(F202:F204)","v":283527624.29000002},{"$f":"F199-F205","v":0},null,0.99999999999999978,303784588.36000079,0,null,0.99999999999999989,323051687.1899994,0,null,1,381426892.52999997,0,null,1,410385213.1899994,0]
[]
[null,"Contract by Source"]
["Non Hardship Refinance","Non Hardship Refinance",null,null,{"$f":"F208/F$210","v":1},{"$f":"IFERROR(VLOOKUP($A208,'[7]Refinance vs Hardship'!$A$2:$C$3,3,FALSE),0)","v":283527624.29000002},null,null,1,303784588.36000079,null,null,1,323051687.18999928,null,null,1,383251538.41999996,null,null,1,410385213.18999952]
["Refinance - Hardship","Hardship Refinance",null,null,{"$f":"F209/F$210","v":0},{"$f":"IFERROR(VLOOKUP($A209,'[7]Refinance vs Hardship'!$A$2:$C$3,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,{"$f":"SUM(E208:E209)","v":1},{"$f":"SUM(F208:F209)","v":283527624.29000002},{"$f":"F205-F210","v":0},null,1,303784588.36000079,0,null,1,323051687.18999928,0,null,1,383251538.41999996,0,null,1,410385213.18999952,0]
[]
[null,"Payment Frequency Distribution"]
["6 Consecutive","6 Consecutive",null,null,{"$f":"F213/F$219","v":1.1274947151993436E-2},{"$f":"IFERROR(VLOOKUP($A$213,'[7]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":3196758.98},null,null,1.2171626842432878E-2,3697552.65,null,null,1.1903066049422673E-2,3845305.5699999994,null,null,1.1712234342242514E-2,4488731.8299999991,null,null,1.2388169959832968E-2,5083921.7699999996]
["Annual","Annual",null,null,0.7019528242032379,{"$f":"IFERROR(VLOOKUP($A$214,'[7]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":199023016.61000001},null,null,0.68521964133783142,208159166.68000004,null,null,0.67409444818012088,217767348.80999991,null,null,0.69340474860343537,265748436.64999989,null,null,0.68479321044613084,281029007.65999955]
["Monthly","Monthly",null,null,0.23637141935578135,{"$f":"IFERROR(VLOOKUP($A$215,'[7]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":67017826.979999997},null,null,0.24899147079299208,75639771.460000098,null,null,0.25877671742612618,83598255.169999883,null,null,0.23977651896414276,91894719.769999996,null,null,0.24760382397831499,101612948.0899999]
["Quarterly","Quarterly",null,null,1.4812057874489521E-2,{"$f":"IFERROR(VLOOKUP($A$216,'[7]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":4199627.58},null,null,1.5338630919874351E-2,4659639.68,null,null,1.5523908832119676E-2,5015024.9400000004,null,null,1.3970175650364975E-2,5354091.3099999996,null,null,1.4114368826730304E-2,5792328.2599999988]
["Semi Annual","Semi Annual",null,null,2.6755017783526607E-2,{"$f":"IFERROR(VLOOKUP($A$217,'[7]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":7585786.6299999999},null,null,2.9142606140074034E-2,8853074.6100000031,null,null,3.0462983479829467E-2,9841118.209999999,null,null,3.2817316355340312E-2,12577286.979999999,null,null,3.2746301933101622E-2,13438598.100000001]
["Structured","Structured",null,null,8.8337336309714121E-3,{"$f":"IFERROR(VLOOKUP($A$218,'[7]Payment Frequency'!$A$1:$C$8,3,FALSE),0)","v":2504607.5099999998},null,null,9.1360239667952828E-3,2775383.2800000003,null,null,9.2388760323812089E-3,2984634.49,null,null,8.3190060844739993E-3,3188271.88,null,null,8.3541248558892875E-3,3428409.3099999987]
["0% to 1%",null,null,null,{"$f":"SUM(E213:E218)","v":1.0000000000000002},{"$f":"SUM(F213:F218)","v":283527624.28999996},{"$f":"F210-F219","v":0},null,1,303784588.36000013,6.5565109252929688E-7,null,1,323051687.18999976,-4.76837158203125E-7,null,1,383251538.4199999,0,null,1,410385213.18999946,0]
["1.01% to 2%"]
["2.01% to 3%","Yield Distribution"]
["01. 0% to 1%",null,null,null,{"$f":"F222/F$236","v":0.18222580769468341},{"$f":"IFERROR(VLOOKUP($A$222,'[7]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":51666050.340000004},null,null,0.18536973232910309,56312467.829999954,null,null,0.19047925489956954,61534644.670000002,null,null,0.18439888484557762,70671156.300000027,null,null,0.18563182498178873,76180556.070000097]
["02. 1.01% to 2%",null,null,null,0.12286226669176312,{"$f":"IFERROR(VLOOKUP($A$223,'[7]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":34834846.590000004},null,null,0.12223272790256304,37132418.929999992,null,null,0.12208019974464568,39438214.499999985,null,null,0.12894250150626699,49417412.069999978,null,null,0.12910621702997338,52983282.399999999]
["03. 2.01% to 3%",null,null,null,0.32967730599115641,{"$f":"IFERROR(VLOOKUP($A$224,'[7]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":93472623.349999994},null,null,0.33229562172645044,100946288.66000001,null,null,0.33003551112021701,106618528.70000009,null,null,0.33889215799485012,129880940.90999998,null,null,0.33208506944158278,136282802.01999983]
["04. 3.01% to 4%",null,null,null,0.29747185178588859,{"$f":"IFERROR(VLOOKUP($A$225,'[7]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":84341487.430000007},null,null,0.29273092153910374,88927142.500000075,null,null,0.28934350946455417,93472908.909999937,null,null,0.27863191756578037,106786111.05999993,null,null,0.28307789512439169,116170982.33999988]
[null,"< 4%",null,null,{"$f":"SUM(E222:E225)","v":0.93223723216349152},{"$f":"SUM(F222:F225)","v":264315007.71000001},null,null,0.93262900349722033,283318317.92000002,null,null,0.93193847522898632,301064296.77999997,null,null,0.93086546191247499,356755620.33999991,null,null,0.92990100657773667,381617622.8299998]
["05. 4.01% to 5%","4% to 5%",null,null,{"$f":"F227/F$236","v":2.9131699603110999E-2},{"$f":"IFERROR(VLOOKUP($A$227,'[7]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":8259641.5800000001},null,null,2.8514511110533273E-2,8662269.0199999958,null,null,2.7987081103472002E-2,9041273.7699999958,null,null,2.7083948919794664E-2,10379965.09,null,null,2.6961732597507792E-2,11064696.380000001]
["06. 5.01% to 6%","5% to 6%",null,null,3.0332820308202068E-2,{"$f":"IFERROR(VLOOKUP($A$228,'[7]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":8600192.4800000004},null,null,3.0016380782273613E-2,9118513.8800000027,null,null,3.0522500395426602E-2,9860345.2500000037,null,null,3.2514800492056462E-2,12461347.310000008,null,null,3.3558998344377006E-2,13772116.690000005]
["07. 6.01% to 7%","6% to 7%",null,null,8.1494774478717141E-3,{"$f":"IFERROR(VLOOKUP($A$229,'[7]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":2310601.98},null,null,8.6388813671153183E-3,2624359.0200000005,null,null,9.2613093465763359E-3,2991881.6100000013,null,null,9.2778218573080218E-3,3555739.5,null,null,9.3239895761752112E-3,3826427.4499999993]
["08. 7.01% to 8%","7% to 8%",null,null,1.4877047732342493E-4,{"$f":"IFERROR(VLOOKUP($A$230,'[7]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":42180.54},null,null,2.0122324285773064E-4,61128.520000000004,null,null,2.9063392553891715E-4,93889.78,null,null,2.5796681836578555E-4,98866.180000000008,null,null,2.5427290420351528E-4,104349.84]
["09. 8.01% to 9%","8% to 9%",null,null,0,{"$f":"IFERROR(VLOOKUP($A$231,'[7]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["10. 9.01% to 10%","9% to 10%",null,null,0,{"$f":"IFERROR(VLOOKUP($A$232,'[7]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["11. 10.01% to 11%","10% to 11%",null,null,0,{"$f":"IFERROR(VLOOKUP($A$233,'[7]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["12. 11.01% to 12%","11% to 12%",null,null,0,{"$f":"IFERROR(VLOOKUP($A$234,'[7]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["13. > 12%","> 12%",null,null,0,{"$f":"IFERROR(VLOOKUP($A$235,'[7]Contract Yield'!$A$1:$C$10,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,{"$f":"SUM(E226:E235)","v":0.99999999999999978},{"$f":"SUM(F226:F235)","v":283527624.29000008},{"$f":"F219-F236","v":0},null,1.0000000000000002,303784588.35999995,0,null,1.0000000000000002,323051687.18999994,0,null,1,383251538.4199999,0,null,1.0000000000000002,410385213.18999976,0]
[]
[null,"Top 5 Obligor",null,null,{"$f":"F238/E13","v":2.9479236638511892E-2},{"$f":"SUM('[7]Top 5 Obligor '!$E$2:$E$6)","v":8358177.9299999997},null,null,2.8380049417724859E-2,8621421.6300000008,null,null,2.7556576773933552E-2,8902198.6199999992,null,null,2.6533466902501881E-2,10168992.009999998,null,null,2.641781343856708E-2,10841479.999999998]